package light.head.dao.sys;

import java.io.Serializable;
import java.util.List;

import light.head.framework.base.BaseDAO;
import light.head.model.OrganSynopsisAnnex;

import org.springframework.stereotype.Service;

@Service
public class OrganSynopsisAnnexDAO extends BaseDAO<OrganSynopsisAnnex, Serializable>{
	private static final String sql_getList4 = "FROM OrganSynopsisAnnex osa WHERE osa.deleted = 0 AND osa.odc = ?";
	private static final String sql_getShowImg = "FROM OrganSynopsisAnnex osa WHERE osa.deleted = 0 AND osa.odc = ? AND osa.cover = 1";
	
	public List<OrganSynopsisAnnex> getAnnexList4(Integer code){
		return super.find(sql_getList4, code);
	}
	public List<OrganSynopsisAnnex> getImgList(Integer code){
		return super.find(sql_getShowImg, code);
	}
}
